Math & Trig Functions

These functions are used for advanced mathematical operations like rounding, ranking, analysing trends and to calculate probabilities and logarithms

  • Family: PQL
  • Library: Spreadsheet
  • This function can be used with the Solve plug-in
  • Function List

    ABS

    ACOS

    ACOSH

    ACOT

    ACOTH

    AGGREGATE

    ARABIC

    ASIN

    ASINH

    ATAN

    ATAN2

    ATANH

    BASE

    CEILING

    CEILING.MATH

    CEILING.PRECISE

    COMBIN

    COMBINA

    COS

    COSH

    COT

    COTH

    CSC

    CSCH

    DECIMAL

    DEGREES

    EVEN

    EXP

    FACT

    FACTDOUBLE

    FLOOR.MATH

    FLOOR.PRECISE

    GCD

    INT

    ISO.CEILING

    LCM

    LN

    LOG

    LOG10

    MDETERM

    MINVERSE

    MMULT

    MOD

    MROUND

    MULTINOMIAL

    ODD

    PI

    POWER

    PRODUCT

    QUOTIENT

    RADIANS

    RAND

    RANDARRAY

    RANDBETWEEN

    ROMAN

    ROUND

    ROUNDDOWN

    ROUNDUP

    SEC

    SECH

    SEQUENCE

    SERIESSUM

    SIGN

    SIN

    SINH

    SQRT

    SQRTPI

    SUBTOTAL

    SUM

    SUMIF

    SUMIFS

    SUMPRODUCT

    SUMSQ

    SUMX2MY2

    SUMX2PY2

    SUMXMY2

    TAN

    TANH

    TRUNC